Project: Investigate a Dataset (Gapminder World)

Table of Contents

Introduction

We will explore these indicators in this data investigation ...

Population rate ---> The human population explosion not only affects humans but also our environment and wildlife.As more population requires more resources, deforestation is happening at a faster rate which takes away the homes of these animals. Similarly, their habitat is being destroyed owing to human activities.the increased need calls for faster rates of industrialization. These industries pollute our water and lands, harming and degrading our quality of life.

Crime Rate ---> Murder is the unlawful killing of another human without justification or valid excuse, especially the unlawful killing of another human with malice aforethought. , In this file we will explore the murder rate in the whole world .. To calculate the Murder ratio we have to divide the murder rate on the country population ...

GDP Growth Rate ---> Economics is a social science devoted to the study of how people and societies get what they need and want. In this file , We will explore the world economic growth since 1990 till 2016 ...

Unemployemnt rate ---->Unemployment is a very serious issue not only in India but in the whole world. There are hundreds and thousands of people out there who do not have employment.It will lead to an increase in poverty, an increase in crime rate, exploitation of labor, political instability, mental health, and loss of skills. As a result, all this will eventually lead to the demise of the nation.

income rate for per person ---> For individuals and businesses, income generally means the value or amount that they receive for their labor and products.Individuals generally consider their gross income to equal the total of their earnings in the form of wages and salaries, the return on their investments and sales of property, and other receipts. Their net income is composed of their gross income reduced by costs incurred in producing the income.

Data Wrangling

Exploring the collected data ...

------------------------------------------------------------------------------------------------------------------------------------------------

Functions

This Function replace K , M , B With thousand , million , billion.. as numbers ....

Droping all years except years from 1990 till 2016 ..

This function will return only the data in 2000, 2005, 2010 and 2016 , it will help me in visualizing my data since there are alot of years ...

------------------------------------------------------------------------------------------------------------------------------------------------

Data Cleaning ..

Checking for Nan Values in each data ..

Removing NaN values from Unemployment and GDP dataframes..

Rechecking forr Nan Values ..

Droping all the other years except years from 1990 till 2016 ..

Replacing K , M , B with numbers ...

------------------------------------------------------------------------------------------------------------------------------------------------

Joining Total murder data with population data to calculate the murder rate ...

Here i joined the total murder data to the right side of the population data and i marked its years by adding _Murder_counts to them .. in order to be able to calculate the murder ratio .... Murder ratio = total murder / population * 100k per population ...

Removing NaN rows in The DataFrame...

Checking if There is any NaN Values..

Making the Country column my indeces ...

------------------------------------------------------------------------------------------------------------------------------------------------

Working on the GDP Data ...

Making the Country column my indeces ...

Transposing the columns with the indeces

------------------------------------------------------------------------------------------------------------------------------------------------

Working on the Income Data ...

------------------------------------------------------------------------------------------------------------------------------------------------

Working on UnEmployment Dataframe ...

------------------------------------------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------------------------------------------

Exploratory Data Analysis

I Found it hard to compare the data bcz its big ... So i decided to visualize few countries alone like (Russia , Egypt , Afghanistan, China, Japan, and United States ..

-----------------------------------------------------------------------------------------------

Murder Rate Data ..

Egypt

Understanding the Chart ..

As we can see from the chart that murder rate in Egypt increases with an average of 1.125 every 5 Years ....

Exploring more details ..

-----------------------------------------------------------------------------------------------

Japan

Understanding the Chart ..

As we can see from the chart that murder rate in Japan decreases with an average of 2.515 every 5 Years ....

Exploring more details ..

-----------------------------------------------------------------------------------------------

Russia

Understanding the Chart ..

As we can see from the chart that murder rate in Russia increases with an average of 166.292 every 5 Years ....

Exploring more details ..

-----------------------------------------------------------------------------------------------

Afghanistan

Understanding the Chart ..

As we can see from the chart that murder rate in Afghanistan increases and decreases with an average of 17.5925 every 5 Years ....

Exploring more details ..

-----------------------------------------------------------------------------------------------

United States

Understanding the Chart ..

As we can see from the chart that murder rate in USA decreases with an average of 61.04 every 5 Years ....

Exploring more details ..

-----------------------------------------------------------------------------------------------

China

Understanding the Chart ..

As we can see from the chart that murder rate in China decreases with an average of 163.535 every 5 Years ....

Exploring more details ..

------------------------------------------------------------------------------------------------------------------------------------------------

Question 1 : Which country has the most and least Murder rate?

Answer :

Calulating the countries that has the most and least Murder rate ...

Which Country has the most murder Rate?

Which Country has the Least murder Rate?

------------------------------------------------------------------------------------------------------------------------------------------------

Population rate

-----------------------------------------------------------------------------------------------

Egypt

Understanding the Chart ..

As we can see from the chart that Egypt population has increased 25M person in only 16 years...

-----------------------------------------------------------------------------------------------

Russia

Understanding the Chart ..

As we can see from the chart that Russia population has decreased 100k person in 16 years...

Exploring more details ..

-----------------------------------------------------------------------------------------------

China

Understanding the Chart ..

As we can see from the chart that China population has increased 120M person in only 16 years...

Exploring more details ..

-----------------------------------------------------------------------------------------------

Japan

Understanding the Chart ..

As we can see from the chart that Japan population has increased in 2010 with 1M person but decreased in 2016 to be same as 2000 population which is 128M person...

Exploring more details ..

-----------------------------------------------------------------------------------------------

United States

Understanding the Chart ..

As we can see from the chart that USA population has increased 41M person in only 16 years...

Exploring more details ..

-----------------------------------------------------------------------------------------------

Afghanistan

Understanding the Chart ..

As we can see from the chart that Egypt population has increased 146M person in only 16 years...

Exploring more details ..

------------------------------------------------------------------------------------------------------------------------------------------------

Question 2 : Which is the most and least country in Population?

Answer:

Calulating the countries that has the most and least population rate

Which country has the most population ?

Which country has the least population ?

------------------------------------------------------------------------------------------------------------------------------------------------

GDP Data

Understanding the Chart ..

As we can see from chart that Afghanistan GDP Increased from 0% in 2000 to 14.8% in 2010 then decreased to 2.4% in 2016 ..

While Russia and Japan had a 10% and 2.9% in their GDP in 2000 but decreased alot in 2016 with a 0.1 % for Russia and 0.4 for Japan. ...

Egypt had more increase in GDP than USA by 6.2% to 4.1% in 2000 and same for 2016 Egypt Had 4.3% Increase while USA had 1.8% increase .

But for China it started with 8.8% increase in 2000 but decreased to 7% in 2016 ...

-----------------------------------------------------------------------------------------------

Egypt

Understanding the Chart ..

As we can see from the chart that there is a decrease in Egypt GDP since 2000 till 2016 by 2.1% ..

Exploring more details ..

-----------------------------------------------------------------------------------------------

Russia

Understanding the Chart ..

As we can see from the chart that there is a decrease in Russia GDP since 2000 till 2016 by 9.8% ..

Exploring more details ..

-----------------------------------------------------------------------------------------------

United States

Understanding the Chart ..

As we can see from the chart that there is a decrease in USA GDP since 2000 till 2016 by 3.6% ..

Exploring more details ..

-----------------------------------------------------------------------------------------------

Afghanistan

Understanding the Chart ..

As we can see from the chart that there is an increase in Afghanistan GDP since 2000 till 2016 by 2.3% ..

Exploring more details ..

-----------------------------------------------------------------------------------------------

China

Understanding the Chart ..

As we can see from the chart that there is a decrease in China GDP since 2000 till 2016 by 2.3% ..

Exploring more details ..

-----------------------------------------------------------------------------------------------

Japan

Understanding the Chart ..

As we can see from the chart that there is a decrease in Japan GDP since 2000 till 2016 by 2% ..

Exploring more details ..

------------------------------------------------------------------------

Question 3 : Which country has the most and least GDP Rate?

Answer:

Which country has the most GDP growth?

Which country has the least GDP growth ?

------------------------------------------------------------------------------------------------------------------------------------------------

Income Data

Understanding the Chart ..

As we can see from chart that :

Afghanistan income per person Increased from \$578 in 2000 to \\$2060 in 2016.

Russia income per person Increased from \$14600 in 2000 to \\$25600 in 2016.

Japan income per person Increased from \$35700 in 2000 to \\$40200 in 2016.

Egypt income per person Increased from \$7750 in 2000 to \\$10800 in 2016.

USA income per person Increased from \$50200 in 2000 to \\$59000 in 2016.

China income per person Increased from \$3450 in 2000 to \\$13500 in 2016.

-----------------------------------------------------------------------------------------------

Egypt

Understanding the Chart ..

As we can see from chart that : Egypt income per person Increased by \$3050 in 16 years.

Exploring more details ..

-----------------------------------------------------------------------------------------------

Russia

Understanding the Chart ..

As we can see from chart that : Russia income per person Increased by \$11000 in 16 years.

Exploring more details ..

-----------------------------------------------------------------------------------------------

China

Understanding the Chart ..

As we can see from chart that : China income per person Increased by \$10050 in 16 years.

Exploring more details ..

-----------------------------------------------------------------------------------------------

Japan

Understanding the Chart ..

As we can see from chart that : Japan income per person Increased by \$4500 in 16 years.

Exploring more details ..

-----------------------------------------------------------------------------------------------

United States

Understanding the Chart ..

As we can see from chart that : USA income per person Increased by \$8800 in 16 years.

Exploring more details ..

-----------------------------------------------------------------------------------------------

Afghanistan

Understanding the Chart ..

As we can see from chart that : Afghanistan income per person Increased by \$1482 in 16 years.

Exploring more details ..

--------------------------------------------------------------------------------------------------------------------------

Question 4 : Which country has the most and least Income Rate?

Answer

Calulating the countries that has the most and least income rate ...

Which country has the most income per person?

Which country has the least income per person?

--------------------------------------------------------------------------------------------------------------------------

UnEmployment Ratio Data

Understanding the Chart ..

As we can see from chart that :

Afghanistan Unemployment rate Increased from 10.81 in 2000 to 11.16 in 2016.

Russia Unemployment rate decreased from 10.58 in 2000 to 5.56 in 2016.

Japan Unemployment rate decreased from 4.75 in 2000 to 3.1 in 2016.

Egypt Unemployment rate Increased from 8.95 in 2000 to 12.41 in 2016.

USA Unemployment rate Increased from 3.99 in 2000 to 9.63 in 2010 surpassing Egypt by 0.68, and then decreased to 4.87 in 2016.

China Unemployment rate Increased from 3.26 in 2000 to 4.53 in 2016.

-----------------------------------------------------------------------------------------------

Egypt

Understanding the Chart ..

As we can see from chart that : Egypt Unemployment rate Increased 3.46 in only 16 years ..

Exploring more details ..

-----------------------------------------------------------------------------------------------

Russia

Understanding the Chart ..

As we can see from chart that : Russia Unemployment rate decreased 5.02 in only 16 years ..

Exploring more details ..

-----------------------------------------------------------------------------------------------

China

Understanding the Chart ..

As we can see from chart that : China Unemployment rate Increased 1.27 in 16 years ..

Exploring more details ..

-----------------------------------------------------------------------------------------------

Afghanistan

Understanding the Chart ..

As we can see from chart that : Afghanistan Unemployment rate Increased 0.35 in 16 years ..

Exploring more details ..

-----------------------------------------------------------------------------------------------

United States

Understanding the Chart ..

As we can see from chart that : USA Unemployment rate Increased 0.88 in 16 years ..

Exploring more details ..

-----------------------------------------------------------------------------------------------

Japan

Understanding the Chart ..

As we can see from chart that : Japan Unemployment rate Increased 1.65 in 16 years ..

Exploring more details ..

--------------------------------------------------------------------------------------------------------------------------

Question 5 : Which country has the most and least Unemployment Rate?

Answer:

Calulating the countries that has the most and least Unemployment rate ...

Which country has the most Unemployment rate?

Which country has the least Unemployment rate?

------------------------------------------------------------------------------------------------------------------------------------------------

Dependant Questions..

Question 6 : Does Unemployment rate have an effect on Murder rate ?

Highest country in unemployment rate is North Macedonia ... Lets's investigate it ...

Macedonia Unemployment rate ..
Macedonia Murder rate ..

Lets visualize it and see ...

Answer :

As we can see That the increase in Unemployent doesnt effect the Murder rate...

--------------------------------------------------------------------------------------------------------------------------

Question 7 : Does increase in Income rate will lead to decrease the Murder rate ?

Highest country in Income rate is Luxembourg ... Lets's investigate it ...

Luxembourg Income rate ..
Luxembourg Murder rate ..

Lets visualize it and see ...

Answer :

As we can see from the chart that decreasing the income rate increase the murder rate , like when the income was less than \$70k the murder rate was 8.3 which is high rate .. But when the income increased to more than 100k the murder rate decreased by 2.74 ...

--------------------------------------------------------------------------------------------------------------------------

Question 8 : Does the increase in Population effect the Unemployment Rate ?

Highest country in Population is China ... Lets's investigate it ...

China Population ..
China Unemployment rate ..

Lets visualize it and see ...

Answer :

As we can see from the chart that the increase in Population increases the Unemployment rate .. Then the answer will be Yes the unemployment rate increases by increasing the population...

--------------------------------------------------------------------------------------------------------------------------

Question 9: Does the increase in Murder rate effect the Economy?

Highest country in Murder Rate is Brazil ... Lets's investigate it ...

Brazil Murder Rate ..
Brazil GDP rate ..

Lets visualize it and see ...

Answer :

As we can see from the chart that the increase in Murder rate doesnt Effect the Economy , As we can see that when Barzil had an 60000 murder rate its economy was increasing by a rate of 7.8 ..

--------------------------------------------------------------------------------------------------------------------------

Conclusions

We have investigated 5 indicators Unemplyment rate , Crime rate , GDP growth rate , Income Rate , Population rate ..

We compared countries and seen who has the most and least value of all the 5 indicators ...

Which country has the most and least Murder rate?

The country with the most Murder Rate is Brazil with an average of --> 52555.555555555555 ....

The country with the Least Murder Rate is Andorra with an average of --> 0.5137037037037038 ....

Which is the most and least country in Population?

The country with the most Population Rate is China with an average of --> 1308888888.8888888 ....

The country with the most Population Rate is Holy See with an average of --> 785.5925925925926 ....

Which country has the most and least GDP Rate?

The country with the most economy Growth is Equatorial Guinea with an average of --> 19.974110408814813 ....

The country with the least Growth is Ukraine with an average of --> -1.8408876753703698 ....

Which country has the most and least Income Rate?

The country with the most Income Rate is Luxembourg with an average of --> \$95451.85185185185 ....

The country with the least Income Rate is Somalia with an average of --> \$732.1481481481482 ....

Which country has the most and least Unemployment Rate?

The country with the most Unemployment rate is North Macedonia with an average of --> 30.729629517037043 ....

The country with the least Unemployment Rate is Kosovo with an average of --> 0.0 ....

Does Unemployment rate have an effect on Murder rate ?

No, the increase in Unemployent doesnt effect the Murder rate

Does increase in Income rate will lead to decrease the Murder rate ?

Yes, Increasing the income rate will decrease the murder rate ..

Does the increase in Population effect the Unemployment Rate ?

Yes, Increasing in Population will increase the Unemployment rate ..

Does the increase in Murder rate effect the Economy?

No, Increasing in Murder rate doesnt Effect the Economy ..

Limitations

There Was no nan limitaions since the years doesnt depend on each others .. So changing NaN Values to 0 didnt effect the analysis ..

But there was a limations in years , Beaceause Not all data have the same amount years , Like the Unemployment data and GDP data both start from 1950 , but for Population data it starts from 1850 , same for Income Data it starts from 1800, But Murder Data starts from 1990 to 2016 , So i had to drop all the other years during visualization and keep years from 1990 to 2016 ,Inorder to be able to Visualize datas Evenly then compare them to each other...